Overview

Dataset info

Number of variables79
Number of observations1202
Missing cells54338 (57.2%)
Duplicate rows0 (0.0%)
Total size in memory741.9 KiB
Average record size in memory632.1 B

Variables types

Numeric22
Categorical41
Boolean0
Date0
URL0
Text (Unique)1
Rejected15
Unsupported0

Warnings

5y_projected_pop has constant value "nan" Rejected
abc_egates has 1165 (> 99.9%) missing values Missing
abi has 1190 (> 99.9%) missing values Missing
abm has 1014 (84.4%) missing values Missing
airport_name has a high cardinality: 1201 distinct values Warning
airporthub has 939 (78.1%) missing values Missing
airporthub_wireless has 1122 (93.3%) missing values Missing
airportnetwork has constant value "nan" Rejected
aodb has 786 (65.4%) missing values Missing
apc_kiosks has 1163 (> 99.9%) missing values Missing
beacons has 1191 (> 99.9%) missing values Missing
bfst has 1179 (> 99.9%) missing values Missing
bmsg has 910 (75.7%) missing values Missing
bridges has 697 (58.0%) zeros Zeros
brs has 948 (78.9%) missing values Missing
bws has 1200 (> 99.9%) missing values Missing
cargo has 364 (30.3%) zeros Zeros
cdm has 1188 (> 99.9%) missing values Missing
checkin_counters has 664 (55.2%) zeros Zeros
city has a high cardinality: 929 distinct values Warning
city has 240 (20.0%) missing values Missing
clf has 1166 (> 99.9%) missing values Missing
common_iws has 848 (70.5%) zeros Zeros
competition_cute has 431 (35.9%) missing values Missing
country has a high cardinality: 174 distinct values Warning
country_code has a high cardinality: 175 distinct values Warning
current_cute_service has 792 (65.9%) missing values Missing
cuss_vendor has 857 (71.3%) missing values Missing
cute_contract_type has 796 (66.2%) missing values Missing
cy_gdp_country_state has constant value "nan" Rejected
cy_population_country_state has constant value "nan" Rejected
dedicated_iws has 1067 (88.8%) zeros Zeros
domestic_passenger has 241 (20.0%) missing values Missing
employees_airport_authority has 781 (65.0%) missing values Missing
employees_other has 884 (73.5%) missing values Missing
employees_total is highly correlated with employees_other (ρ = 0.99593) Rejected
expressip has 787 (65.5%) missing values Missing
fids has a high cardinality: 66 distinct values Warning
fids has 575 (47.8%) missing values Missing
flightyield has constant value "nan" Rejected
gatelink has constant value "Available" Rejected
gates has 574 (47.8%) zeros Zeros
iflow has 1193 (> 99.9%) missing values Missing
international_passenger has 371 (30.9%) missing values Missing
iqueue has 1156 (> 99.9%) missing values Missing
itrack has 1179 (> 99.9%) missing values Missing
latitude has a high cardinality: 1162 distinct values Warning
latitude has 38 (< 0.1%) missing values Missing
ldcs has 1014 (84.4%) missing values Missing
length_longest_runway has 651 (54.2%) zeros Zeros
longitude has a high cardinality: 1165 distinct values Warning
longitude has 38 (< 0.1%) missing values Missing
mdns has constant value "SITA" Rejected
movements has 192 (16.0%) zeros Zeros
no_kiosks has 1013 (84.3%) zeros Zeros
number_sita_staff has 1026 (85.4%) missing values Missing
operating_revenue has 1051 (87.4%) missing values Missing
owner_mgmt_group has 1168 (> 99.9%) missing values Missing
paging has 1164 (> 99.9%) missing values Missing
parking_spaces has 572 (47.6%) missing values Missing
passenger is highly correlated with movements (ρ = 0.92998) Rejected
past_3_yr_cagr_oper_rev is highly correlated with operating_revenue (ρ = 0.99681) Rejected
past_3_yr_cagr_pax has 392 (32.6%) zeros Zeros
past_4_yr_cagr_gdp has constant value "nan" Rejected
pbmg has constant value "SITA" Rejected
percent_chg_cargo has 438 (36.4%) zeros Zeros
percent_chg_move is highly skewed (γ1 = 29.526) Skewed
percent_chg_move has 229 (19.1%) zeros Zeros
percent_chg_pass has 200 (16.6%) zeros Zeros
projected_5_yr_cagr_pop has constant value "nan" Rejected
prs has 1168 (> 99.9%) missing values Missing
rms has 872 (72.5%) missing values Missing
runways has 646 (53.7%) zeros Zeros
sbd has 1063 (88.4%) missing values Missing
sbg has 1165 (> 99.9%) missing values Missing
sita_admin_email has a high cardinality: 371 distinct values Warning
sita_admin_email has 792 (65.9%) missing values Missing
sita_cute has 801 (66.6%) missing values Missing
uds has constant value "nan" Rejected
website has a high cardinality: 782 distinct values Warning
website has 322 (26.8%) missing values Missing
work_team has constant value "SITA SGS" Rejected
year_opened has a high cardinality: 110 distinct values Warning
year_opened has 675 (56.2%) missing values Missing

Variables

5y_projected_pop
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

abc_egates
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1165
VISION-BOX
 
28
SITA
 
3
EMARATECH
 
3
Other values (3)
 
3
(Missing)
1165
ValueCountFrequency (%) 
VISION-BOX 28 < 0.1%
 
SITA 3 < 0.1%
 
EMARATECH 3 < 0.1%
 
GUNNEBO 1 < 0.1%
 
SAFRAN 1 < 0.1%
 
SITA trial 1 < 0.1%
 
(Missing) 1165 > 99.9%
 
Max length10
Mean length3.1922
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

abi
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1190
LEIDOS
 
6
ULTRA
 
2
SITA
 
2
(Missing)
1190
ValueCountFrequency (%) 
LEIDOS 6 < 0.1%
 
ULTRA 2 < 0.1%
 
SITA 2 < 0.1%
 
AMADEUS 2 < 0.1%
 
(Missing) 1190 > 99.9%
 
Max length7
Mean length3.0266
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

abm
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)84.4%
Missing (n)1014
GENTRACK
 
95
AIRIT (A1)
 
80
LEIDOS
 
6
Other values (3)
 
7
(Missing)
1014
ValueCountFrequency (%) 
GENTRACK 95 7.9%
 
AIRIT (A1) 80 6.7%
 
LEIDOS 6 < 0.1%
 
SITA 5 < 0.1%
 
GENTRACK/ULTRA 1 < 0.1%
 
ULTRA 1 < 0.1%
 
(Missing) 1014 84.4%
 
Max length14
Mean length3.891
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

airport_code
Categorical, Unique

First 5 values
AAL
AAN
ABC
ABE
ABJ
Last 5 values
ZLO
ZQN
ZRH
ZTH
ZYL

First 5 values

ValueCountFrequency (%) 
AAL 1 < 0.1%
 
AAN 1 < 0.1%
 
ABC 1 < 0.1%
 
ABE 1 < 0.1%
 
ABJ 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
ZYL 1 < 0.1%
 
ZTH 1 < 0.1%
 
ZRH 1 < 0.1%
 
ZQN 1 < 0.1%
 
ZLO 1 < 0.1%
 

airport_name
Categorical

Distinct count1201
Unique (%)> 99.9%
Missing (%)0.0%
Missing (n)0
BASEL-MULHOUSE AIRPORT (MLH OR BSL)
 
2
MAPUTO INTERNATIONAL AIRPORT (MPM)
 
1
ASSIUT INTERNATIONAL AIRPORT (ATZ)
 
1
Other values (1198)
1198
ValueCountFrequency (%) 
BASEL-MULHOUSE AIRPORT (MLH OR BSL) 2 < 0.1%
 
MAPUTO INTERNATIONAL AIRPORT (MPM) 1 < 0.1%
 
ASSIUT INTERNATIONAL AIRPORT (ATZ) 1 < 0.1%
 
AEROPUERTO DE ALICANTE (ALC) 1 < 0.1%
 
AEROPUERTO DE MAR DEL PLATA (MDQ) 1 < 0.1%
 
FAISALABAD AIRPORT (LYP) 1 < 0.1%
 
GODTHAB/NUUK AIRPORT (GOH) 1 < 0.1%
 
GÖTEBORG-LANDVETTER AIRPORT (GOT) 1 < 0.1%
 
COPENHAGEN INTERNATIONAL AIRPORT (CPH) 1 < 0.1%
 
FLUGHAFEN DRESDEN (DRS) 1 < 0.1%
 
Other values (1191) 1191 > 99.9%
 
Max length73
Mean length31.447
Min length5
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

airporthub
Categorical

Distinct count18
Unique (%)< 0.1%
Missing (%)78.1%
Missing (n)939
Type 0, Full APH
 
147
Type 0, CUTE only
 
29
Type 2, Back-Office Only
 
16
Other values (14)
 
71
(Missing)
939
ValueCountFrequency (%) 
Type 0, Full APH 147 12.2%
 
Type 0, CUTE only 29 < 0.1%
 
Type 2, Back-Office Only 16 < 0.1%
 
Type 1, Full APH 16 < 0.1%
 
Type 3, Back-Office Only 11 < 0.1%
 
Type 0, Back-Office Only 7 < 0.1%
 
Type 1, Back-Office Only 7 < 0.1%
 
Type 2, Full APH 7 < 0.1%
 
Type 0, CUTE Only 4 < 0.1%
 
Type 1, CUTE Only 4 < 0.1%
 
Other values (7) 15 < 0.1%
 
(Missing) 939 78.1%
 
Max length47
Mean length6.1897
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

airporthub_wireless
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)93.3%
Missing (n)1122
Ready For Service
 
47
Open For Sales
 
33
(Missing)
1122
ValueCountFrequency (%) 
Ready For Service 47 < 0.1%
 
Open For Sales 33 < 0.1%
 
(Missing) 1122 93.3%
 
Max length17
Mean length3.8494
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

airportnetwork
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

aodb
Categorical

Distinct count27
Unique (%)< 0.1%
Missing (%)65.4%
Missing (n)786
AIRIT (A1)
 
69
LEIDOS
 
62
SITA
 
59
Other values (23)
226
(Missing)
786
ValueCountFrequency (%) 
AIRIT (A1) 69 5.7%
 
LEIDOS 62 5.2%
 
SITA 59 < 0.1%
 
GENTRACK 59 < 0.1%
 
AENA INDRA 48 < 0.1%
 
SITA HOSTED 35 < 0.1%
 
AMADEUS 16 < 0.1%
 
ROCKWELL COLLINS 15 < 0.1%
 
ULTRA 12 < 0.1%
 
SITA/AIRIT (A1) 8 < 0.1%
 
Other values (16) 33 < 0.1%
 
(Missing) 786 65.4%
 
Max length24
Mean length4.9077
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

apc_kiosks
Categorical

Distinct count10
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1163
YVR
 
21
SITA
 
9
SITA/YVR
 
2
Other values (6)
 
7
(Missing)
1163
ValueCountFrequency (%) 
YVR 21 < 0.1%
 
SITA 9 < 0.1%
 
SITA/YVR 2 < 0.1%
 
DEDO 2 < 0.1%
 
GCR/DAON 1 < 0.1%
 
HAS-GCR 1 < 0.1%
 
IBM 1 < 0.1%
 
GCR 1 < 0.1%
 
IBM/YVR 1 < 0.1%
 
(Missing) 1163 > 99.9%
 
Max length8
Mean length3.0283
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

beacons
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1191
PROXAMA/EYE AIRPORTS
 
7
SITA
 
3
ARUBA NETWORKS
 
1
(Missing)
1191
ValueCountFrequency (%) 
PROXAMA/EYE AIRPORTS 7 < 0.1%
 
SITA 3 < 0.1%
 
ARUBA NETWORKS 1 < 0.1%
 
(Missing) 1191 > 99.9%
 
Max length20
Mean length3.1106
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

bfst
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1179
SITA
 
22
SITA/ROCKWELL COLLINS
 
1
(Missing)
1179
ValueCountFrequency (%) 
SITA 22 < 0.1%
 
SITA/ROCKWELL COLLINS 1 < 0.1%
 
(Missing) 1179 > 99.9%
 
Max length21
Mean length3.0333
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

bmsg
Categorical

Distinct count10
Unique (%)< 0.1%
Missing (%)75.7%
Missing (n)910
SITA
242
ROCKWELL COLLINS
 
20
BROCK
 
11
Other values (6)
 
19
(Missing)
910
ValueCountFrequency (%) 
SITA 242 20.1%
 
ROCKWELL COLLINS 20 < 0.1%
 
BROCK 11 < 0.1%
 
SITA/ROCKWELL COLLINS 8 < 0.1%
 
SITA/BROCK 4 < 0.1%
 
ROCKWELL COLLINS/BROCK 3 < 0.1%
 
GENTRACK 2 < 0.1%
 
SITA/ROCKWELL COLLINS/BROCK 1 < 0.1%
 
SITA/GENTRACK 2020 1 < 0.1%
 
(Missing) 910 75.7%
 
Max length27
Mean length3.6672
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

bridges
Numeric

Distinct count91
Unique (%)7.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean8.8935
Minimum0
Maximum205
Zeros (%)58.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q38
95-th percentile46.95
Maximum205
Range205
Interquartile range8

Descriptive statistics

Standard deviation21.705
Coef of variation2.4405
Kurtosis22.736
Mean8.8935
MAD11.961
Skewness4.3011
Sum10690
Variance471.1
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 697 58.0%
 
2 46 < 0.1%
 
6 36 < 0.1%
 
4 35 < 0.1%
 
5 32 < 0.1%
 
8 27 < 0.1%
 
3 23 < 0.1%
 
7 18 < 0.1%
 
10 17 < 0.1%
 
11 16 < 0.1%
 
Other values (81) 255 21.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 697 58.0%
 
1 10 < 0.1%
 
2 46 < 0.1%
 
3 23 < 0.1%
 
4 35 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
205 1 < 0.1%
 
181 1 < 0.1%
 
163 1 < 0.1%
 
157 1 < 0.1%
 
151 1 < 0.1%
 

brs
Categorical

Distinct count48
Unique (%)< 0.1%
Missing (%)78.9%
Missing (n)948
SITA
 
153
RESA
 
18
ULTRA
 
13
Other values (44)
 
70
(Missing)
948
ValueCountFrequency (%) 
SITA 153 12.7%
 
RESA 18 < 0.1%
 
ULTRA 13 < 0.1%
 
ZAFIRE 9 < 0.1%
 
QUANTUM 7 < 0.1%
 
BROCK 4 < 0.1%
 
AMADEUS 4 < 0.1%
 
TRAVSYS 4 < 0.1%
 
COFELY 3 < 0.1%
 
ULTRA/ACS 2 < 0.1%
 
Other values (37) 37 < 0.1%
 
(Missing) 948 78.9%
 
Max length40
Mean length3.6647
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

bws
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1200
MERLIN
 
1
SCARABEE
 
1
(Missing)
1200
ValueCountFrequency (%) 
MERLIN 1 < 0.1%
 
SCARABEE 1 < 0.1%
 
(Missing) 1200 > 99.9%
 
Max length8
Mean length3.0067
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

cargo
Numeric

Distinct count760
Unique (%)63.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean85110
Minimum0
Maximum4.4601e+06
Zeros (%)30.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median675
Q323537
95-th percentile4.2441e+05
Maximum4.4601e+06
Range4.4601e+06
Interquartile range23537

Descriptive statistics

Standard deviation3.366e+05
Coef of variation3.9549
Kurtosis66.782
Mean85110
MAD1.3209e+05
Skewness7.3189
Sum1.023e+08
Variance1.133e+11
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 364 30.3%
 
1 10 < 0.1%
 
2 7 < 0.1%
 
3 6 < 0.1%
 
4 6 < 0.1%
 
6 5 < 0.1%
 
8 4 < 0.1%
 
13 3 < 0.1%
 
31 3 < 0.1%
 
22 3 < 0.1%
 
Other values (750) 791 65.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 364 30.3%
 
1 10 < 0.1%
 
2 7 < 0.1%
 
3 6 < 0.1%
 
4 6 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4.4601e+06 1 < 0.1%
 
4.2906e+06 1 < 0.1%
 
3.2752e+06 1 < 0.1%
 
2.6307e+06 1 < 0.1%
 
2.5957e+06 1 < 0.1%
 

cdm
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1188
GENTRACK
 
3
ULTRA
 
3
SAAB SENSIS
 
3
Other values (3)
 
5
(Missing)
1188
ValueCountFrequency (%) 
GENTRACK 3 < 0.1%
 
ULTRA 3 < 0.1%
 
SAAB SENSIS 3 < 0.1%
 
AMADEUS 3 < 0.1%
 
INTERSYSTEMS 1 < 0.1%
 
SITA 1 < 0.1%
 
(Missing) 1188 > 99.9%
 
Max length12
Mean length3.0557
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

checkin_counters
Numeric

Distinct count166
Unique (%)13.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean27.66
Minimum0
Maximum632
Zeros (%)55.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q321
95-th percentile145.9
Maximum632
Range632
Interquartile range21

Descriptive statistics

Standard deviation68.785
Coef of variation2.4868
Kurtosis22.057
Mean27.66
MAD37.718
Skewness4.2661
Sum33247
Variance4731.4
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 664 55.2%
 
16 23 < 0.1%
 
4 22 < 0.1%
 
20 19 < 0.1%
 
10 17 < 0.1%
 
12 16 < 0.1%
 
6 15 < 0.1%
 
8 14 < 0.1%
 
17 13 < 0.1%
 
40 13 < 0.1%
 
Other values (156) 386 32.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 664 55.2%
 
1 10 < 0.1%
 
2 11 < 0.1%
 
3 11 < 0.1%
 
4 22 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
632 1 < 0.1%
 
569 1 < 0.1%
 
518 1 < 0.1%
 
490 1 < 0.1%
 
487 1 < 0.1%
 

city
Categorical

Distinct count929
Unique (%)77.3%
Missing (%)20.0%
Missing (n)240
LONDON, GB
 
5
SANTIAGO
 
3
HOUSTON, TX
 
3
Other values (925)
951
(Missing)
240
ValueCountFrequency (%) 
LONDON, GB 5 < 0.1%
 
SANTIAGO 3 < 0.1%
 
HOUSTON, TX 3 < 0.1%
 
STOCKHOLM 2 < 0.1%
 
CHICAGO, IL 2 < 0.1%
 
PHOENIX, AZ 2 < 0.1%
 
ROME 2 < 0.1%
 
TAIPEI 2 < 0.1%
 
HARARE 2 < 0.1%
 
YAOUNDÉ 2 < 0.1%
 
Other values (918) 937 78.0%
 
(Missing) 240 20.0%
 
Max length25
Mean length8.7895
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

clf
Categorical

Distinct count9
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1166
SITA
 
17
DAMAREL
 
11
UNISYS/DAMAREL
 
2
Other values (5)
 
6
(Missing)
1166
ValueCountFrequency (%) 
SITA 17 < 0.1%
 
DAMAREL 11 < 0.1%
 
UNISYS/DAMAREL 2 < 0.1%
 
DAMAREL/ROCKWELL COLLINS 2 < 0.1%
 
ROCKWELL COLLINS 1 < 0.1%
 
DAMAREL/MERCATOR DMACS 1 < 0.1%
 
ULTRA 1 < 0.1%
 
UNISYS 1 < 0.1%
 
(Missing) 1166 > 99.9%
 
Max length24
Mean length3.1348
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

common_iws
Numeric

Distinct count163
Unique (%)13.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean33.169
Minimum0
Maximum1266
Zeros (%)70.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q312
95-th percentile179
Maximum1266
Range1266
Interquartile range12

Descriptive statistics

Standard deviation107
Coef of variation3.2258
Kurtosis36.659
Mean33.169
MAD51.272
Skewness5.4301
Sum39869
Variance11448
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 848 70.5%
 
7 13 < 0.1%
 
12 12 < 0.1%
 
19 10 < 0.1%
 
13 10 < 0.1%
 
14 9 < 0.1%
 
8 9 < 0.1%
 
25 8 < 0.1%
 
10 7 < 0.1%
 
11 7 < 0.1%
 
Other values (153) 269 22.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 848 70.5%
 
2 2 < 0.1%
 
5 2 < 0.1%
 
6 4 < 0.1%
 
7 13 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1266 1 < 0.1%
 
858 1 < 0.1%
 
855 1 < 0.1%
 
808 1 < 0.1%
 
800 1 < 0.1%
 

competition_cute
Categorical

Distinct count31
Unique (%)< 0.1%
Missing (%)35.9%
Missing (n)431
SITA
364
RESA
144
ROCKWELL COLLINS
109
Other values (27)
154
(Missing)
431
ValueCountFrequency (%) 
SITA 364 30.3%
 
RESA 144 12.0%
 
ROCKWELL COLLINS 109 9.1%
 
AIRIT (A1) 32 < 0.1%
 
TRAVELSKY 28 < 0.1%
 
SITA/ROCKWELL COLLINS 24 < 0.1%
 
ULTRA 21 < 0.1%
 
AMADEUS 14 < 0.1%
 
ROCKWELL COLLINS/ULTRA 7 < 0.1%
 
SITA/ULTRA 3 < 0.1%
 
Other values (20) 25 < 0.1%
 
(Missing) 431 35.9%
 
Max length30
Mean length5.7587
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

country
Categorical

Distinct count174
Unique (%)14.5%
Missing (%)0.0%
Missing (n)0
UNITED STATES
 
164
FRANCE
 
91
SPAIN
 
48
Other values (171)
899
ValueCountFrequency (%) 
UNITED STATES 164 13.6%
 
FRANCE 91 7.6%
 
SPAIN 48 < 0.1%
 
NORWAY 48 < 0.1%
 
INDIA 47 < 0.1%
 
CHINA 43 < 0.1%
 
PAKISTAN 41 < 0.1%
 
TURKEY 38 < 0.1%
 
ITALY 35 < 0.1%
 
UNITED KINGDOM 33 < 0.1%
 
Other values (164) 614 51.1%
 
Max length29
Mean length8.3852
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

country_code
Categorical

Distinct count175
Unique (%)14.6%
Missing (%)0.0%
Missing (n)0
US
 
164
FR
 
91
ES
 
48
Other values (172)
899
ValueCountFrequency (%) 
US 164 13.6%
 
FR 91 7.6%
 
ES 48 < 0.1%
 
NO 48 < 0.1%
 
IN 47 < 0.1%
 
CN 43 < 0.1%
 
PK 41 < 0.1%
 
TR 38 < 0.1%
 
IT 35 < 0.1%
 
GB 32 < 0.1%
 
Other values (165) 615 51.2%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

current_cute_service
Categorical

Distinct count14
Unique (%)< 0.1%
Missing (%)65.9%
Missing (n)792
Lite Site
192
Single Cute
 
128
Regional Airport
 
52
Other values (10)
 
38
(Missing)
792
ValueCountFrequency (%) 
Lite Site 192 16.0%
 
Single Cute 128 10.6%
 
Regional Airport 52 < 0.1%
 
Hub Site 24 < 0.1%
 
Cute/Lite Large 5 < 0.1%
 
Single Cute, Regional Airport 2 < 0.1%
 
Single Cute, Hub Site 1 < 0.1%
 
Lite Site, Hub Site 1 < 0.1%
 
Hub Site, Lite Site 1 < 0.1%
 
Single Cute & Hub Site 1 < 0.1%
 
Other values (3) 3 < 0.1%
 
(Missing) 792 65.9%
 
Max length40
Mean length5.688
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

cuss_vendor
Categorical

Distinct count36
Unique (%)< 0.1%
Missing (%)71.3%
Missing (n)857
SITA
 
156
ROCKWELL COLLINS
 
35
TRAVELSKY
 
28
Other values (32)
 
126
(Missing)
857
ValueCountFrequency (%) 
SITA 156 13.0%
 
ROCKWELL COLLINS 35 < 0.1%
 
TRAVELSKY 28 < 0.1%
 
SITA (WN DEDICATED ONLY) 16 < 0.1%
 
MATERNA 14 < 0.1%
 
ROCKWELL COLLINS/EMBROSS 12 < 0.1%
 
NO PROVIDER 10 < 0.1%
 
IER 10 < 0.1%
 
NCR 9 < 0.1%
 
SITA (REGIONAL AIRPORT) 8 < 0.1%
 
Other values (25) 47 < 0.1%
 
(Missing) 857 71.3%
 
Max length48
Mean length4.9101
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

cute_contract_type
Categorical

Distinct count9
Unique (%)< 0.1%
Missing (%)66.2%
Missing (n)796
DIRECT D
313
CLUB
 
55
AENA UCA
 
21
Other values (5)
 
17
(Missing)
796
ValueCountFrequency (%) 
DIRECT D 313 26.0%
 
CLUB 55 < 0.1%
 
AENA UCA 21 < 0.1%
 
VAR 11 < 0.1%
 
OPTION E 3 < 0.1%
 
CLUB/DED 1 < 0.1%
 
DIRECT D, CLUB 1 < 0.1%
 
Var 1 < 0.1%
 
(Missing) 796 66.2%
 
Max length14
Mean length4.4609
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

cy_gdp_country_state
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

cy_population_country_state
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

dedicated_iws
Numeric

Distinct count65
Unique (%)5.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5.5033
Minimum0
Maximum784
Zeros (%)88.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile19
Maximum784
Range784
Interquartile range0

Descriptive statistics

Standard deviation40.418
Coef of variation7.3443
Kurtosis260.22
Mean5.5033
MAD9.9279
Skewness14.956
Sum6615
Variance1633.6
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 1067 88.8%
 
3 10 < 0.1%
 
2 9 < 0.1%
 
5 7 < 0.1%
 
1 6 < 0.1%
 
19 6 < 0.1%
 
4 5 < 0.1%
 
8 5 < 0.1%
 
14 4 < 0.1%
 
7 4 < 0.1%
 
Other values (55) 79 6.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1067 88.8%
 
1 6 < 0.1%
 
2 9 < 0.1%
 
3 10 < 0.1%
 
4 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
784 1 < 0.1%
 
758 1 < 0.1%
 
620 1 < 0.1%
 
206 1 < 0.1%
 
200 1 < 0.1%
 

domestic_passenger
Numeric

Distinct count953
Unique (%)79.3%
Missing (%)20.0%
Missing (n)241
Infinite (%)0.0%
Infinite (n)0
Mean3.7199e+06
Minimum2
Maximum9.0258e+07
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile1014
Q179197
Median6.2441e+05
Q32.802e+06
95-th percentile1.9334e+07
Maximum9.0258e+07
Range9.0258e+07
Interquartile range2.7228e+06

Descriptive statistics

Standard deviation8.6062e+06
Coef of variation2.3136
Kurtosis25.943
Mean3.7199e+06
MAD4.7766e+06
Skewness4.4392
Sum3.5748e+09
Variance7.4066e+13
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
34 2 < 0.1%
 
2.8438e+05 2 < 0.1%
 
875 2 < 0.1%
 
9.4700e+05 2 < 0.1%
 
1323 2 < 0.1%
 
3584 2 < 0.1%
 
21999 2 < 0.1%
 
2 2 < 0.1%
 
118 2 < 0.1%
 
7.2362e+05 1 < 0.1%
 
Other values (942) 942 78.4%
 
(Missing) 241 20.0%
 

Minimum 5 values

ValueCountFrequency (%) 
2 2 < 0.1%
 
8 1 < 0.1%
 
32 1 < 0.1%
 
34 2 < 0.1%
 
39 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9.0258e+07 1 < 0.1%
 
7.1337e+07 1 < 0.1%
 
6.5881e+07 1 < 0.1%
 
6.2696e+07 1 < 0.1%
 
5.6318e+07 1 < 0.1%
 

employees_airport_authority
Numeric

Distinct count227
Unique (%)18.9%
Missing (%)65.0%
Missing (n)781
Infinite (%)0.0%
Infinite (n)0
Mean469.46
Minimum2
Maximum13000
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile12
Q153
Median160
Q3450
95-th percentile2000
Maximum13000
Range12998
Interquartile range397

Descriptive statistics

Standard deviation1002.4
Coef of variation2.1353
Kurtosis66.707
Mean469.46
MAD500.17
Skewness6.7378
Sum1.9764e+05
Variance1.0049e+06
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
30 11 < 0.1%
 
300 9 < 0.1%
 
350 8 < 0.1%
 
1000 7 < 0.1%
 
10 6 < 0.1%
 
150 6 < 0.1%
 
110 6 < 0.1%
 
200 6 < 0.1%
 
250 5 < 0.1%
 
100 5 < 0.1%
 
Other values (216) 352 29.3%
 
(Missing) 781 65.0%
 

Minimum 5 values

ValueCountFrequency (%) 
2 2 < 0.1%
 
3 1 < 0.1%
 
4 4 < 0.1%
 
5 2 < 0.1%
 
8 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
13000 1 < 0.1%
 
7711 1 < 0.1%
 
5000 1 < 0.1%
 
4800 1 < 0.1%
 
4436 1 < 0.1%
 

employees_other
Numeric

Distinct count217
Unique (%)18.1%
Missing (%)73.5%
Missing (n)884
Infinite (%)0.0%
Infinite (n)0
Mean4527.9
Minimum1
Maximum61000
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile10
Q1266.25
Median1000
Q34453.8
95-th percentile21240
Maximum61000
Range60999
Interquartile range4187.5

Descriptive statistics

Standard deviation8791.8
Coef of variation1.9417
Kurtosis15.406
Mean4527.9
MAD5313
Skewness3.565
Sum1.4399e+06
Variance7.7295e+07
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
1000 10 < 0.1%
 
3000 6 < 0.1%
 
400 6 < 0.1%
 
1800 6 < 0.1%
 
200 6 < 0.1%
 
700 6 < 0.1%
 
250 5 < 0.1%
 
1500 5 < 0.1%
 
100 5 < 0.1%
 
30 5 < 0.1%
 
Other values (206) 258 21.5%
 
(Missing) 884 73.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 < 0.1%
 
2 4 < 0.1%
 
3 3 < 0.1%
 
4 2 < 0.1%
 
6 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
61000 1 < 0.1%
 
59791 1 < 0.1%
 
52000 1 < 0.1%
 
47342 1 < 0.1%
 
39700 1 < 0.1%
 

employees_total
Highly correlated

This variable is highly correlated with employees_other and should be ignored for analysis

Correlation0.99593

expressip
Categorical

Distinct count10
Unique (%)< 0.1%
Missing (%)65.5%
Missing (n)787
SITA
403
SITA T1, T2
 
4
SITA T1, T3
 
2
Other values (6)
 
6
(Missing)
787
ValueCountFrequency (%) 
SITA 403 33.5%
 
SITA T1, T2 4 < 0.1%
 
SITA T1, T3 2 < 0.1%
 
SITA T4, T5, T7, T8 1 < 0.1%
 
SITA T6, TB 1 < 0.1%
 
SITA T6, TD 1 < 0.1%
 
SITA T2, T3 1 < 0.1%
 
SITA T3, T5 1 < 0.1%
 
SITA T1, T4 1 < 0.1%
 
(Missing) 787 65.5%
 
Max length19
Mean length3.4218
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

fids
Categorical

Distinct count66
Unique (%)5.5%
Missing (%)47.8%
Missing (n)575
CONRAC
142
SITA
 
106
LEIDOS
 
62
Other values (62)
317
(Missing)
575
ValueCountFrequency (%) 
CONRAC 142 11.8%
 
SITA 106 8.8%
 
LEIDOS 62 5.2%
 
AIRIT (A1) 57 < 0.1%
 
GENTRACK 39 < 0.1%
 
INFAX 30 < 0.1%
 
INTERSYSTEMS 21 < 0.1%
 
SITA HOSTED 19 < 0.1%
 
SITA/CONRAC 17 < 0.1%
 
ROCKWELL COLLINS 16 < 0.1%
 
Other values (55) 118 9.8%
 
(Missing) 575 47.8%
 
Max length46
Mean length5.5749
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

flightyield
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

gatelink
Constant

This variable is constant and should be ignored for analysis

Constant valueAvailable

gates
Numeric

Distinct count100
Unique (%)8.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean11.444
Minimum0
Maximum242
Zeros (%)47.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q310
95-th percentile56.95
Maximum242
Range242
Interquartile range10

Descriptive statistics

Standard deviation26.813
Coef of variation2.3429
Kurtosis24.087
Mean11.444
MAD14.665
Skewness4.3856
Sum13756
Variance718.94
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 574 47.8%
 
2 49 < 0.1%
 
4 49 < 0.1%
 
1 41 < 0.1%
 
3 36 < 0.1%
 
6 36 < 0.1%
 
8 36 < 0.1%
 
5 31 < 0.1%
 
10 22 < 0.1%
 
12 21 < 0.1%
 
Other values (90) 307 25.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 574 47.8%
 
1 41 < 0.1%
 
2 49 < 0.1%
 
3 36 < 0.1%
 
4 49 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
242 1 < 0.1%
 
231 1 < 0.1%
 
227 1 < 0.1%
 
208 1 < 0.1%
 
207 1 < 0.1%
 

geo
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
EURO
463
AMER
310
MEIA
281
ValueCountFrequency (%) 
EURO 463 38.5%
 
AMER 310 25.8%
 
MEIA 281 23.4%
 
APAC 148 12.3%
 
Max length4
Mean length4
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

iflow
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1193
RESA
 
4
XOVIS
 
2
LEIDOS
 
1
Other values (2)
 
2
(Missing)
1193
ValueCountFrequency (%) 
RESA 4 < 0.1%
 
XOVIS 2 < 0.1%
 
LEIDOS 1 < 0.1%
 
SITA 1 < 0.1%
 
GORDIO AIRPORTS-acp-IT AG 1 < 0.1%
 
(Missing) 1193 > 99.9%
 
Max length25
Mean length3.0283
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

international_passenger
Numeric

Distinct count824
Unique (%)68.6%
Missing (%)30.9%
Missing (n)371
Infinite (%)0.0%
Infinite (n)0
Mean3.4112e+06
Minimum3
Maximum7.7453e+07
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum3
5-th percentile279
Q171386
Median5.1149e+05
Q32.7192e+06
95-th percentile1.6711e+07
Maximum7.7453e+07
Range7.7453e+07
Interquartile range2.6478e+06

Descriptive statistics

Standard deviation8.1602e+06
Coef of variation2.3922
Kurtosis29.614
Mean3.4112e+06
MAD4.3062e+06
Skewness4.8637
Sum2.8347e+09
Variance6.6589e+13
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
14 3 < 0.1%
 
3 3 < 0.1%
 
8 2 < 0.1%
 
542 2 < 0.1%
 
8.5301e+05 2 < 0.1%
 
6.7444e+06 2 < 0.1%
 
2.141e+06 1 < 0.1%
 
2.963e+05 1 < 0.1%
 
1.8295e+05 1 < 0.1%
 
7.0929e+05 1 < 0.1%
 
Other values (813) 813 67.6%
 
(Missing) 371 30.9%
 

Minimum 5 values

ValueCountFrequency (%) 
3 3 < 0.1%
 
7 1 < 0.1%
 
8 2 < 0.1%
 
10 1 < 0.1%
 
14 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7.7453e+07 1 < 0.1%
 
6.9816e+07 1 < 0.1%
 
6.8071e+07 1 < 0.1%
 
6.0367e+07 1 < 0.1%
 
5.8246e+07 1 < 0.1%
 

iqueue
Categorical

Distinct count16
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1156
LEIDOS+BLIPTRACK
 
17
SITA
 
7
BLUELON
 
4
Other values (12)
 
18
(Missing)
1156
ValueCountFrequency (%) 
LEIDOS+BLIPTRACK 17 < 0.1%
 
SITA 7 < 0.1%
 
BLUELON 4 < 0.1%
 
XOVIS 3 < 0.1%
 
SITA+XOVIS 2 < 0.1%
 
HUMAN RECOGNITION SYSTEMS 2 < 0.1%
 
BLUE EYE VIDEO 2 < 0.1%
 
INFAX 2 < 0.1%
 
HUMAN RECOGNITION SYSTEMS/LEIDOS+BLIPTRACK 1 < 0.1%
 
LEIDOS+BLIPTRACK/XOVIS 1 < 0.1%
 
Other values (5) 5 < 0.1%
 
(Missing) 1156 > 99.9%
 
Max length42
Mean length3.386
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

itrack
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1179
ROCKWELL COLLINS
 
7
AIRSPHERE
 
7
SITA CUA
 
6
(Missing)
1179
ValueCountFrequency (%) 
ROCKWELL COLLINS 7 < 0.1%
 
AIRSPHERE 7 < 0.1%
 
SITA CUA 6 < 0.1%
 
RESA 3 < 0.1%
 
(Missing) 1179 > 99.9%
 
Max length16
Mean length3.1381
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

latitude
Categorical

Distinct count1162
Unique (%)> 99.9%
Missing (%)< 0.1%
Missing (n)38
45°43'46"N
 
2
48°06'37"N
 
2
43°05'50"N
 
2
Other values (1158)
1158
(Missing)
 
38
ValueCountFrequency (%) 
45°43'46"N 2 < 0.1%
 
48°06'37"N 2 < 0.1%
 
43°05'50"N 2 < 0.1%
 
45°04'47"N 1 < 0.1%
 
39°29'22"N 1 < 0.1%
 
50°28'27"N 1 < 0.1%
 
19°20'13"N 1 < 0.1%
 
08°58'30"N 1 < 0.1%
 
36°24'19"N 1 < 0.1%
 
20°00'04"N 1 < 0.1%
 
Other values (1151) 1151 > 99.9%
 
(Missing) 38 < 0.1%
 
Max length10
Mean length9.7787
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

ldcs
Categorical

Distinct count15
Unique (%)< 0.1%
Missing (%)84.4%
Missing (n)1014
SITA
 
101
DAMAREL-ROCKWELL COLLINS
 
33
DAMAREL
 
14
Other values (11)
 
40
(Missing)
1014
ValueCountFrequency (%) 
SITA 101 8.4%
 
DAMAREL-ROCKWELL COLLINS 33 < 0.1%
 
DAMAREL 14 < 0.1%
 
ROCKWELL COLLINS 12 < 0.1%
 
RESA 7 < 0.1%
 
AIRIT (A1) 7 < 0.1%
 
SITA/ROCKWELL COLLINS 5 < 0.1%
 
ULTRA 3 < 0.1%
 
TRAVYS 1 < 0.1%
 
DAMAREL-RESA 1 < 0.1%
 
Other values (4) 4 < 0.1%
 
(Missing) 1014 84.4%
 
Max length27
Mean length4.0075
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

length_longest_runway
Numeric

Distinct count348
Unique (%)29.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1010.7
Minimum0
Maximum4876
Zeros (%)54.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q32009
95-th percentile3399.5
Maximum4876
Range4876
Interquartile range2009

Descriptive statistics

Standard deviation1268.9
Coef of variation1.2554
Kurtosis-0.70597
Mean1010.7
MAD1116.1
Skewness0.84178
Sum1.2148e+06
Variance1.61e+06
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 651 54.2%
 
2500 16 < 0.1%
 
3000 14 < 0.1%
 
1200 12 < 0.1%
 
3048 11 < 0.1%
 
2000 11 < 0.1%
 
2438 9 < 0.1%
 
2743 8 < 0.1%
 
1000 7 < 0.1%
 
800 7 < 0.1%
 
Other values (338) 456 37.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 651 54.2%
 
408 1 < 0.1%
 
416 1 < 0.1%
 
448 1 < 0.1%
 
490 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4876 1 < 0.1%
 
4423 1 < 0.1%
 
4422 1 < 0.1%
 
4397 1 < 0.1%
 
4267 1 < 0.1%
 

longitude
Categorical

Distinct count1165
Unique (%)> 99.9%
Missing (%)< 0.1%
Missing (n)38
003°24'49"W
 
1
021°02'09"E
 
1
058°32'09"W
 
1
Other values (1161)
1161
(Missing)
 
38
ValueCountFrequency (%) 
003°24'49"W 1 < 0.1%
 
021°02'09"E 1 < 0.1%
 
058°32'09"W 1 < 0.1%
 
005°13'05"E 1 < 0.1%
 
068°21'58"W 1 < 0.1%
 
004°51'07"W 1 < 0.1%
 
002°07'00"E 1 < 0.1%
 
006°54'21"W 1 < 0.1%
 
098°18'33"E 1 < 0.1%
 
057°40'59"E 1 < 0.1%
 
Other values (1154) 1154 > 99.9%
 
(Missing) 38 < 0.1%
 
Max length11
Mean length10.747
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

mdns
Constant

This variable is constant and should be ignored for analysis

Constant valueSITA

movements
Numeric

Distinct count1001
Unique (%)83.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean61142
Minimum0
Maximum8.825e+05
Zeros (%)16.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q13690
Median20353
Q371617
95-th percentile2.6773e+05
Maximum8.825e+05
Range8.825e+05
Interquartile range67927

Descriptive statistics

Standard deviation1.0086e+05
Coef of variation1.6496
Kurtosis13.52
Mean61142
MAD65025
Skewness3.17
Sum7.3492e+07
Variance1.0172e+10
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 192 16.0%
 
11998 2 < 0.1%
 
3537 2 < 0.1%
 
42374 2 < 0.1%
 
1885 2 < 0.1%
 
3726 2 < 0.1%
 
2347 2 < 0.1%
 
6815 2 < 0.1%
 
49000 2 < 0.1%
 
41892 2 < 0.1%
 
Other values (991) 992 82.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 192 16.0%
 
28 1 < 0.1%
 
62 1 < 0.1%
 
145 1 < 0.1%
 
160 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
8.825e+05 1 < 0.1%
 
8.7514e+05 1 < 0.1%
 
6.8126e+05 1 < 0.1%
 
6.5556e+05 1 < 0.1%
 
5.9017e+05 1 < 0.1%
 

no_kiosks
Numeric

Distinct count64
Unique (%)5.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.8037
Minimum0
Maximum283
Zeros (%)84.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile20
Maximum283
Range283
Interquartile range0

Descriptive statistics

Standard deviation16.973
Coef of variation4.4624
Kurtosis98.483
Mean3.8037
MAD6.5455
Skewness8.482
Sum4572
Variance288.1
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 1013 84.3%
 
1 19 < 0.1%
 
8 14 < 0.1%
 
2 13 < 0.1%
 
4 12 < 0.1%
 
10 11 < 0.1%
 
5 7 < 0.1%
 
12 7 < 0.1%
 
6 6 < 0.1%
 
20 5 < 0.1%
 
Other values (54) 95 7.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1013 84.3%
 
1 19 < 0.1%
 
2 13 < 0.1%
 
3 5 < 0.1%
 
4 12 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
283 1 < 0.1%
 
214 1 < 0.1%
 
164 1 < 0.1%
 
145 1 < 0.1%
 
111 1 < 0.1%
 

number_sita_staff
Numeric

Distinct count24
Unique (%)< 0.1%
Missing (%)85.4%
Missing (n)1026
Infinite (%)0.0%
Infinite (n)0
Mean5.9716
Minimum1
Maximum110
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median3
Q36
95-th percentile16.25
Maximum110
Range109
Interquartile range4

Descriptive statistics

Standard deviation10.226
Coef of variation1.7125
Kurtosis64.47
Mean5.9716
MAD4.5629
Skewness7.1079
Sum1051
Variance104.58
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
3 35 < 0.1%
 
1 30 < 0.1%
 
2 26 < 0.1%
 
5 16 < 0.1%
 
4 15 < 0.1%
 
6 13 < 0.1%
 
7 7 < 0.1%
 
9 6 < 0.1%
 
12 5 < 0.1%
 
10 5 < 0.1%
 
Other values (13) 18 < 0.1%
 
(Missing) 1026 85.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 30 < 0.1%
 
2 26 < 0.1%
 
3 35 < 0.1%
 
4 15 < 0.1%
 
5 16 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
110 1 < 0.1%
 
54 1 < 0.1%
 
40 1 < 0.1%
 
36 1 < 0.1%
 
24 1 < 0.1%
 

operating_revenue
Numeric

Distinct count152
Unique (%)12.6%
Missing (%)87.4%
Missing (n)1051
Infinite (%)0.0%
Infinite (n)0
Mean1.0057e+08
Minimum1.5055e+05
Maximum1.0112e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.5055e+05
5-th percentile1.623e+06
Q17.7426e+06
Median2.8715e+07
Q31.0226e+08
95-th percentile4.6721e+08
Maximum1.0112e+09
Range1.0111e+09
Interquartile range9.4515e+07

Descriptive statistics

Standard deviation1.7076e+08
Coef of variation1.698
Kurtosis8.6752
Mean1.0057e+08
MAD1.1039e+08
Skewness2.81
Sum1.5186e+10
Variance2.916e+16
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
1.6793e+08 1 < 0.1%
 
5.0901e+07 1 < 0.1%
 
2.2876e+08 1 < 0.1%
 
3.6086e+07 1 < 0.1%
 
1.267e+08 1 < 0.1%
 
5.7712e+07 1 < 0.1%
 
2.1843e+07 1 < 0.1%
 
7.4432e+06 1 < 0.1%
 
4.2807e+06 1 < 0.1%
 
2.4772e+07 1 < 0.1%
 
Other values (141) 141 11.7%
 
(Missing) 1051 87.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1.5055e+05 1 < 0.1%
 
4.5422e+05 1 < 0.1%
 
4.9912e+05 1 < 0.1%
 
5.0655e+05 1 < 0.1%
 
6.1615e+05 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.0112e+09 1 < 0.1%
 
7.6898e+08 1 < 0.1%
 
7.5601e+08 1 < 0.1%
 
6.5954e+08 1 < 0.1%
 
6.5324e+08 1 < 0.1%
 

owner_mgmt_group
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1168
Corporación América S.A., (CASA), Aeropuertos Argentina 2000 S.A. (AA2000)
 
12
Egyptian Airports Co (EAC)
 
10
Corporacion America S.A. (CASA)
 
6
Other values (3)
 
6
(Missing)
1168
ValueCountFrequency (%) 
Corporación América S.A., (CASA), Aeropuertos Argentina 2000 S.A. (AA2000) 12 < 0.1%
 
Egyptian Airports Co (EAC) 10 < 0.1%
 
Corporacion America S.A. (CASA) 6 < 0.1%
 
Corporacion América (CASA) and Andino Investment Holdings of Peru 3 < 0.1%
 
Corporacion America S.A. (CASA), Infravix/Engevix 2 < 0.1%
 
Cairo Airport Co 1 < 0.1%
 
(Missing) 1168 > 99.9%
 
Max length74
Mean length4.282
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

paging
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1164
SITA
 
34
AIRIT (A1)
 
2
GENTRACK
 
1
(Missing)
1164
ValueCountFrequency (%) 
SITA 34 < 0.1%
 
AIRIT (A1) 2 < 0.1%
 
GENTRACK 1 < 0.1%
 
SITA/ROCKWELL COLLINS 1 < 0.1%
 
(Missing) 1164 > 99.9%
 
Max length21
Mean length3.0591
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

parking_spaces
Numeric

Distinct count366
Unique (%)30.4%
Missing (%)47.6%
Missing (n)572
Infinite (%)0.0%
Infinite (n)0
Mean3281
Minimum15
Maximum1e+05
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum15
5-th percentile70
Q1283.75
Median800
Q33137
95-th percentile15000
Maximum1e+05
Range99985
Interquartile range2853.2

Descriptive statistics

Standard deviation6739.1
Coef of variation2.054
Kurtosis71.66
Mean3281
MAD3769.8
Skewness6.3946
Sum2.067e+06
Variance4.5415e+07
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
300 28 < 0.1%
 
200 19 < 0.1%
 
100 12 < 0.1%
 
250 12 < 0.1%
 
1000 11 < 0.1%
 
500 11 < 0.1%
 
400 9 < 0.1%
 
600 9 < 0.1%
 
50 9 < 0.1%
 
3000 8 < 0.1%
 
Other values (355) 502 41.8%
 
(Missing) 572 47.6%
 

Minimum 5 values

ValueCountFrequency (%) 
15 1 < 0.1%
 
20 2 < 0.1%
 
22 1 < 0.1%
 
25 1 < 0.1%
 
27 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1e+05 1 < 0.1%
 
40000 1 < 0.1%
 
38539 1 < 0.1%
 
33100 1 < 0.1%
 
32600 1 < 0.1%
 

passenger
Highly correlated

This variable is highly correlated with movements and should be ignored for analysis

Correlation0.92998

past_3_yr_cagr_oper_rev
Highly correlated

This variable is highly correlated with operating_revenue and should be ignored for analysis

Correlation0.99681

past_3_yr_cagr_pax
Numeric

Distinct count685
Unique (%)57.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.024801
Minimum-0.6638
Maximum1.5425
Zeros (%)32.6%
Mini histogram

Quantile statistics

Minimum-0.6638
5-th percentile-0.06088
Q10
Median1e-06
Q30.053725
95-th percentile0.14392
Maximum1.5425
Range2.2063
Interquartile range0.053725

Descriptive statistics

Standard deviation0.10794
Coef of variation4.3522
Kurtosis51.851
Mean0.024801
MAD0.054635
Skewness2.9846
Sum29.811
Variance0.011651
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 392 32.6%
 
0.0258 3 < 0.1%
 
1e-06 3 < 0.1%
 
0.0839 3 < 0.1%
 
4.8e-05 3 < 0.1%
 
0.0197 3 < 0.1%
 
0.023 3 < 0.1%
 
1.6e-05 3 < 0.1%
 
0.0223 3 < 0.1%
 
0.0588 3 < 0.1%
 
Other values (675) 783 65.1%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.6638 1 < 0.1%
 
-0.6314 1 < 0.1%
 
-0.6199 1 < 0.1%
 
-0.5053 1 < 0.1%
 
-0.4886 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.5425 1 < 0.1%
 
1.1456 1 < 0.1%
 
0.758 1 < 0.1%
 
0.7173 1 < 0.1%
 
0.6094 1 < 0.1%
 

past_4_yr_cagr_gdp
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

pbmg
Constant

This variable is constant and should be ignored for analysis

Constant valueSITA

percent_chg_cargo
Numeric

Distinct count704
Unique (%)58.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.082029
Minimum-0.9989
Maximum20.75
Zeros (%)36.4%
Mini histogram

Quantile statistics

Minimum-0.9989
5-th percentile-0.31693
Q1-0.0227
Median0
Q30.032775
95-th percentile0.37552
Maximum20.75
Range21.749
Interquartile range0.055475

Descriptive statistics

Standard deviation0.88718
Coef of variation10.815
Kurtosis287.36
Mean0.082029
MAD0.22609
Skewness14.799
Sum98.599
Variance0.78708
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 438 36.4%
 
-0.0336 3 < 0.1%
 
3.8e-05 3 < 0.1%
 
0.01 3 < 0.1%
 
-0.0229 2 < 0.1%
 
0.0673 2 < 0.1%
 
-2.9e-05 2 < 0.1%
 
-0.109 2 < 0.1%
 
-0.043 2 < 0.1%
 
-0.0208 2 < 0.1%
 
Other values (694) 743 61.8%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.9989 1 < 0.1%
 
-0.9953 1 < 0.1%
 
-0.9848 1 < 0.1%
 
-0.9057 1 < 0.1%
 
-0.9024 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
20.75 1 < 0.1%
 
11.012 1 < 0.1%
 
10.053 1 < 0.1%
 
8.8159 1 < 0.1%
 
5.1756 1 < 0.1%
 

percent_chg_move
Numeric

Distinct count839
Unique (%)69.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.10743
Minimum-0.9066
Maximum55.817
Zeros (%)19.1%
Mini histogram

Quantile statistics

Minimum-0.9066
5-th percentile-0.12892
Q1-0.01375
Median9.5e-06
Q30.064
95-th percentile0.26069
Maximum55.817
Range56.724
Interquartile range0.07775

Descriptive statistics

Standard deviation1.719
Coef of variation16.001
Kurtosis932.36
Mean0.10743
MAD0.19963
Skewness29.526
Sum129.14
Variance2.955
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 229 19.1%
 
0.0312 4 < 0.1%
 
0.0257 4 < 0.1%
 
-0.0111 3 < 0.1%
 
0.055 3 < 0.1%
 
9.1e-05 3 < 0.1%
 
0.0935 3 < 0.1%
 
9.9e-05 3 < 0.1%
 
-0.0619 3 < 0.1%
 
-0.0178 3 < 0.1%
 
Other values (829) 944 78.5%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.9066 1 < 0.1%
 
-0.7398 1 < 0.1%
 
-0.7377 1 < 0.1%
 
-0.676 1 < 0.1%
 
-0.6139 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
55.817 1 < 0.1%
 
19.001 1 < 0.1%
 
4.6449 1 < 0.1%
 
3.8838 1 < 0.1%
 
2.5246 1 < 0.1%
 

percent_chg_pass
Numeric

Distinct count883
Unique (%)73.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.065824
Minimum-0.8504
Maximum11.231
Zeros (%)16.6%
Mini histogram

Quantile statistics

Minimum-0.8504
5-th percentile-0.11995
Q10
Median0.02475
Q30.092925
95-th percentile0.28247
Maximum11.231
Range12.081
Interquartile range0.092925

Descriptive statistics

Standard deviation0.41453
Coef of variation6.2975
Kurtosis463.7
Mean0.065824
MAD0.12188
Skewness18.595
Sum79.12
Variance0.17183
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 200 16.6%
 
0.0296 4 < 0.1%
 
0.0478 4 < 0.1%
 
9.9e-05 4 < 0.1%
 
-0.0665 3 < 0.1%
 
0.0638 3 < 0.1%
 
0.0195 3 < 0.1%
 
0.1824 3 < 0.1%
 
-0.0103 3 < 0.1%
 
-0.0323 3 < 0.1%
 
Other values (873) 972 80.9%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.8504 1 < 0.1%
 
-0.7584 1 < 0.1%
 
-0.7374 1 < 0.1%
 
-0.7343 1 < 0.1%
 
-0.7332 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
11.231 1 < 0.1%
 
5.4057 1 < 0.1%
 
2.8378 1 < 0.1%
 
2.1619 1 < 0.1%
 
2.0666 1 < 0.1%
 

projected_5_yr_cagr_pop
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

prs
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1168
AIRSPHERE
 
9
ROCKWELL COLLINS
 
7
SITA+AIRSPHERE
 
6
Other values (4)
 
12
(Missing)
1168
ValueCountFrequency (%) 
AIRSPHERE 9 < 0.1%
 
ROCKWELL COLLINS 7 < 0.1%
 
SITA+AIRSPHERE 6 < 0.1%
 
SITA 6 < 0.1%
 
VISION-BOX 3 < 0.1%
 
AIS 2 < 0.1%
 
AMADEUS 1 < 0.1%
 
(Missing) 1168 > 99.9%
 
Max length16
Mean length3.2013
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

rms
Categorical

Distinct count42
Unique (%)< 0.1%
Missing (%)72.5%
Missing (n)872
SITA FRMS
 
64
LEIDOS
 
61
AIRIT (A1)
 
51
Other values (38)
 
154
(Missing)
872
ValueCountFrequency (%) 
SITA FRMS 64 5.3%
 
LEIDOS 61 5.1%
 
AIRIT (A1) 51 < 0.1%
 
GENTRACK 32 < 0.1%
 
SITA MRMS 13 < 0.1%
 
SITA HOSTED FRMS 11 < 0.1%
 
ULTRA 11 < 0.1%
 
SITA FRMS/MRMS 10 < 0.1%
 
ROCKWELL COLLINS 8 < 0.1%
 
AMADEUS 8 < 0.1%
 
Other values (31) 61 5.1%
 
(Missing) 872 72.5%
 
Max length29
Mean length4.8943
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

runways
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.73128
Minimum0
Maximum9
Zeros (%)53.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile3
Maximum9
Range9
Interquartile range1

Descriptive statistics

Standard deviation1.0743
Coef of variation1.4691
Kurtosis8.5847
Mean0.73128
MAD0.78604
Skewness2.3782
Sum879
Variance1.1542
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
0 646 53.7%
 
1 372 30.9%
 
2 108 9.0%
 
3 40 < 0.1%
 
4 22 < 0.1%
 
5 7 < 0.1%
 
6 4 < 0.1%
 
9 1 < 0.1%
 
8 1 < 0.1%
 
7 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 646 53.7%
 
1 372 30.9%
 
2 108 9.0%
 
3 40 < 0.1%
 
4 22 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9 1 < 0.1%
 
8 1 < 0.1%
 
7 1 < 0.1%
 
6 4 < 0.1%
 
5 7 < 0.1%
 

sbd
Categorical

Distinct count23
Unique (%)< 0.1%
Missing (%)88.4%
Missing (n)1063
BBC
 
43
MATERNA
 
30
SITA
 
20
Other values (19)
 
46
(Missing)
1063
ValueCountFrequency (%) 
BBC 43 < 0.1%
 
MATERNA 30 < 0.1%
 
SITA 20 < 0.1%
 
ROCKWELL COLLINS 16 < 0.1%
 
ICM 5 < 0.1%
 
SITA/ICM 4 < 0.1%
 
MATERNA/ROCKWELL COLLINS 3 < 0.1%
 
BCS 3 < 0.1%
 
BAGDROP BV 2 < 0.1%
 
SITA/MATERNA 1 < 0.1%
 
Other values (12) 12 < 0.1%
 
(Missing) 1063 88.4%
 
Max length24
Mean length3.4642
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

sbg
Categorical

Distinct count10
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1165
SITA
 
17
VISION-BOX
 
7
KABA
 
4
Other values (6)
 
9
(Missing)
1165
ValueCountFrequency (%) 
SITA 17 < 0.1%
 
VISION-BOX 7 < 0.1%
 
KABA 4 < 0.1%
 
AIRSPHERE GATECONTROL 4 < 0.1%
 
IER/DAMAREL 1 < 0.1%
 
ARINC 1 < 0.1%
 
SITA/DSG 1 < 0.1%
 
HUMAN RECOGNITION SYSTEMS Trial/KABA 1 < 0.1%
 
RESA 1 < 0.1%
 
(Missing) 1165 > 99.9%
 
Max length36
Mean length3.1589
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

sita_admin_email
Categorical

Distinct count371
Unique (%)30.9%
Missing (%)65.9%
Missing (n)792
jed.cute.admins@sita.aero
 
13
kix.cute.admins@sita.aero
 
7
gig.cute.admins@sita.aero
 
6
Other values (367)
384
(Missing)
792
ValueCountFrequency (%) 
jed.cute.admins@sita.aero 13 < 0.1%
 
kix.cute.admins@sita.aero 7 < 0.1%
 
gig.cute.admins@sita.aero 6 < 0.1%
 
lis.cute.admins@sita.aero 5 < 0.1%
 
sccl2airports@sita.aero 3 < 0.1%
 
syd.cute.admins@sita.aero 3 < 0.1%
 
hcaa.cute.admins@athensairport.gr 3 < 0.1%
 
mad.cute.admins@sita.aero 3 < 0.1%
 
osl.cute.admins@sita.aero 2 < 0.1%
 
tpe.cute.admins@sita.aero 2 < 0.1%
 
Other values (360) 363 30.2%
 
(Missing) 792 65.9%
 
Max length100
Mean length10.791
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

sita_cute
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)66.6%
Missing (n)801
AirportConnect OPEN
357
REGIONAL AIRPORT
 
32
Awarded, not live
 
12
(Missing)
801
ValueCountFrequency (%) 
AirportConnect OPEN 357 29.7%
 
REGIONAL AIRPORT 32 < 0.1%
 
Awarded, not live 12 < 0.1%
 
(Missing) 801 66.6%
 
Max length19
Mean length8.2379
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

tier
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.6839
Minimum1
Maximum5
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q14
Median4
Q34
95-th percentile5
Maximum5
Range4
Interquartile range0

Descriptive statistics

Standard deviation1.0161
Coef of variation0.27581
Kurtosis1.0531
Mean3.6839
MAD0.75209
Skewness-1.2405
Sum4428
Variance1.0324
Memory size9.5 KiB
Histogram
ValueCountFrequency (%) 
4 747 62.1%
 
5 164 13.6%
 
3 111 9.2%
 
2 107 8.9%
 
1 73 6.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 73 6.1%
 
2 107 8.9%
 
3 111 9.2%
 
4 747 62.1%
 
5 164 13.6%
 

Maximum 5 values

ValueCountFrequency (%) 
5 164 13.6%
 
4 747 62.1%
 
3 111 9.2%
 
2 107 8.9%
 
1 73 6.1%
 

uds
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

website
Categorical

Distinct count782
Unique (%)65.1%
Missing (%)26.8%
Missing (n)322
http://www.aena.es
 
30
http://www.ilmailulaitos.com
 
11
http://www.airports.co.za
 
9
Other values (778)
830
(Missing)
322
ValueCountFrequency (%) 
http://www.aena.es 30 < 0.1%
 
http://www.ilmailulaitos.com 11 < 0.1%
 
http://www.airports.co.za 9 < 0.1%
 
http://www.onda.org.ma 6 < 0.1%
 
http://www.swedavia.se 6 < 0.1%
 
http://www.ana-aeroportos.pt 4 < 0.1%
 
http://www.malaysiaairports.com.my 4 < 0.1%
 
http://www.aeroportidipuglia.it 4 < 0.1%
 
http://www.oaca.nat.tn 3 < 0.1%
 
http://www.onda.ma 3 < 0.1%
 
Other values (771) 800 66.6%
 
(Missing) 322 26.8%
 
Max length112
Mean length21.962
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

work_team
Constant

This variable is constant and should be ignored for analysis

Constant valueSITA SGS

year_opened
Categorical

Distinct count110
Unique (%)9.2%
Missing (%)56.2%
Missing (n)675
1942
 
17
1936
 
15
1930
 
14
Other values (106)
481
(Missing)
675
ValueCountFrequency (%) 
1942 17 < 0.1%
 
1936 15 < 0.1%
 
1930 14 < 0.1%
 
1927 13 < 0.1%
 
1929 13 < 0.1%
 
1928 13 < 0.1%
 
1939 13 < 0.1%
 
1940 12 < 0.1%
 
1937 11 < 0.1%
 
1960 10 < 0.1%
 
Other values (99) 396 32.9%
 
(Missing) 675 56.2%
 
Max length45
Mean length3.4725
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Correlations

Pearson matrix
Spearman matrix
Kendall matrix
Phi<sub>k</sub> matrix
Recoded matrix

Missing values

Matrix

Matrix

Count

Bar

Heatmap

Heatmap

Dendrogram

Dendrogram

Sample

First rows

5y_projected_popabc_egatesabiabmairport_codeairport_nameairporthubairporthub_wirelessairportnetworkaodbapc_kiosksbeaconsbfstbmsgbridgesbrsbwscargocdmcheckin_counterscityclfcommon_iwscompetition_cutecountrycountry_codecurrent_cute_servicecuss_vendorcute_contract_typecy_gdp_country_statecy_population_country_statededicated_iwsdomestic_passengeremployees_airport_authorityemployees_otheremployees_totalexpressipfidsflightyieldgatelinkgatesgeoiflowinternational_passengeriqueueitracklatitudeldcslength_longest_runwaylongitudemdnsmovementsno_kiosksnumber_sita_staffoperating_revenueowner_mgmt_grouppagingparking_spacespassengerpast_3_yr_cagr_oper_revpast_3_yr_cagr_paxpast_4_yr_cagr_gdppbmgpercent_chg_cargopercent_chg_movepercent_chg_passprojected_5_yr_cagr_popprsrmsrunwayssbdsbgsita_admin_emailsita_cutetierudswebsitework_teamyear_opened
0NaNNaNNaNAIRIT (A1)ATLHARTSFIELD-JACKSON ATLANTA INTERNATIONAL AIRPO...NaNNaNNaNAIRIT (A1)NaNNaNNaNNaN205RESANaN626202NaN243ATLANTA, GANaN160SITAUNITED STATESUSSingle Cute, Regional AirportSITADIRECT DNaNNaN2590257803.0NaNNaN55300.0NaNINFAX/ULTRA/AIRIT (A1)NaNNaN207AMERNaN11233303.0NaNNaN33°38'12"NNaN3776084°25'40"WNaN88249723NaN389059465.0NaNNaN32000.0101491106496251311.00.020400NaNNaN0.0414000.0162000.055200NaNNaNAIRIT (A1)-ASCENT6NaNNaNainsley.vanreil@sita.aero, atlwn.cute.admins@s...AirportConnect OPEN1NaNhttp://www.atlanta-airport.comNaN1925
1NaNNaNNaNNaNORDCHICAGO O'HARE INTERNATIONAL AIRPORT (ORD)Type 0, CUTE onlyReady For ServiceNaNNaNNaNNaNNaNBROCK181NaNNaN1592830NaN0CHICAGO, ILNaN86SITA/ROCKWELL COLLINSUNITED STATESUSLite SiteSITADIRECT DNaNNaN8665881034.0200.0NaN5000.0SITANaNNaNAvailable195AMERNaN10999683.0NaNNaN41°58'45"NNaN3962087°54'26"WNaN87513603.0659541678.0NaNSITA21105.076949504844524389.00.049100NaNNaN0.156100-0.0000770.099200NaNNaNNaN9NaNNaNord.cute.admins@sita.aeroAirportConnect OPEN1NaNhttp://www.ohare.comSITA SGS1955
2NaNNaNNaNAIRIT (A1)DFWDALLAS/FORT WORTH INTERNATIONAL AIRPORT (DFW)Type 2, Full APHNaNNaNAIRIT (A1)NaNNaNNaNNaN151NaNNaN670029NaN394DALLAS, TXNaN0ROCKWELL COLLINS/AIRIT (A1)UNITED STATESUSNaNROCKWELL COLLINS/EMBROSSNaNNaNNaN056317743.01400.0NaN40000.0SITAAIRIT (A1)NaNNaN161AMERNaN7757019.0NaNNaN32°53'50"NNaN4084097°02'15"WNaN6812610NaN512736769.0NaNNaN40000.064074762624694009.00.030000NaNNaN0.0551000.0000210.000081NaNNaNNaN7NaNNaNNaNNaN1NaNhttp://www.dfwairport.com/NaN1974
3NaNNaNNaNAIRIT (A1)LAXLOS ANGELES INTERNATIONAL AIRPORT (LAX)Type 2, Back-Office OnlyNaNNaNSITA/AIRIT (A1)NaNNaNNaNNaN125NaNNaN1938620NaN632LOS ANGELES, CANaN482SITA/ROCKWELL COLLINSUNITED STATESUSSingle Cute, Lite Site, Regional AirportSITADIRECT D, CLUBNaNNaN5452058695.0NaNNaNNaNNaNSITA/AIRITNaNNaN113AMERNaN20000009.0NaNNaN33°56'33"NNaN3685118°24'29"WNaN65556464NaN768977640.0NaNNaN23000.074937004966740871.00.055700NaNNaN0.067300-0.0749000.060400NaNNaNSITA FRMS4SITANaNlax3.cute.admins@sita.aero, lax6.cute.admins@s...AirportConnect OPEN1NaNhttp://www.airports.ci.la.ca.usNaN1930
4NaNNaNNaNNaNPEKBEIJING CAPITAL INTERNATIONAL AIRPORT (PEK)NaNNaNNaNNaNNaNNaNNaNNaN149NaNNaN1889830NaN518BEIJING, CNNaN593SITACHINACNSingle CuteSITACLUBNaNNaN6571336730.05000.02500.07500.0NaNNaNNaNNaN242APACNaN18601898.0NaNNaN40°04'24"NNaN2400116°35'54"ENaN59016974NaNNaNNaNNaN5000.089938628NaN0.031500NaNNaN0.0224000.0141000.044200NaNNaNNaN2NaNNaNpek.cute.admins@sita.aeroAirportConnect OPEN1NaNhttp://www.bcia.com.cnNaN1958
5NaNNaNNaNNaNCLTCHARLOTTE DOUGLAS INTERNATIONAL AIRPORT (CLT)NaNNaNNaNAIRIT (A1)NaNNaNNaNNaN77NaNNaN135086NaN0CHARLOTTE, NCNaN0AIRIT (A1)UNITED STATESUSNaNNaNNaNNaNNaN042053468.0350.019650.020000.0NaNSITANaNNaN97AMERNaN2823159.0NaNNaN35°12'49"NNaN3048080°56'56"WNaN5439440NaN143636000.0NaNNaN14482.044876627184796000.00.028600NaNNaN0.276200-0.0000220.013400NaNNaNAIRIT (A1)4NaNNaNNaNNaN1NaNhttp://www.charlotteairport.comNaN1935
6NaNNaNNaNAIRIT (A1)DENDENVER INTERNATIONAL AIRPORT (DEN)NaNNaNNaNAIRIT (A1)NaNNaNNaNSITA96NaNNaN247522NaN120DENVER, CONaN0ROCKWELL COLLINS/ULTRAUNITED STATESUSRegional AirportSITA (WN DEDICATED ONLY)DIRECT DNaNNaN051821889.0900.029100.030000.0NaNSITA/AIRITNaNNaN231AMERNaN2192613.0NaNNaN39°51'42"NNaN4876104°40'23"WNaN54121324NaN491979565.0NaNNaN38539.054014502711490823.00.000053NaNNaN0.050700-0.0429000.010100NaNNaNULTRA6BBCNaNdenwn.cute.admins@sita.aeroNaN1NaNhttp://www.flydenver.comNaN1995
7NaNNaNNaNAIRIT (A1)LASMCCARRAN INTERNATIONAL AIRPORT (LAS)NaNNaNNaNNaNNaNNaNNaNNaN103NaNNaN98978NaN382LAS VEGAS, NVNaN0ROCKWELL COLLINSUNITED STATESUSNaNROCKWELL COLLINS/EMBROSSNaNNaNNaN040518092.0900.09100.010000.0NaNNaNNaNNaN110AMERNaN3447379.0NaNNaN36°04'48"NNaN4423115°09'08"WNaN5303300NaN367394064.0NaNNaN12820.043965471481077190.00.025200NaNNaN0.0000320.0151000.025500NaNNaNNaN4NaNNaNNaNNaN1NaNhttp://www.mccarran.comNaN1963
8NaNNaNNaNAIRIT (A1)IAHGEORGE BUSH INTERCONTINENTAL AIRPORT (IAH)NaNReady For ServiceNaNAIRIT (A1)NaNNaNNaNNaN118NaNNaN429785NaN292HOUSTON, TXNaN178SITAUNITED STATESUSSingle CuteSITACLUBNaNNaN1432411513.01242.023850.025092.0NaNINFAX/AIRIT (A1)/ITSNaNAvailable111AMERNaN10611711.0NaNNaN29°59'04"NDAMAREL-ROCKWELL COLLINS3657095°20'29"WNaN50284414NaN321787075.0NaNNaN24843.043023224362342432.00.025500NaNNaN-0.0687000.0000600.043200NaNNaNAIRIT (A1)5NaNNaNiah.cute.admins@sita.aeroAirportConnect OPEN1NaNhttp://www.fly2houston.com/NaN1969
9NaNNaNNaNNaNCDGAÉROPORT DE PARIS-CHARLES DE GAULLE (CDG)NaNNaNNaNNaNNaNNaNNaNNaN163NaNNaN2090800NaN569PARIS, FRNaN0RESAFRANCEFRNaNSITA/IERNaNNaNNaN05340470.04000.061000.065000.0NaNCONRACNaNNaN0EURONaN60366933.0NaNNaN49°00'35"NNaN1007002°32'52"ENaN4758100NaNNaNNaNNaN30000.065766986NaN0.021900NaNNaN0.0000200.0000930.030600NaNNaNSITA MRMS1NaNNaNNaNNaN1NaNhttp://www.adp.frNaN1974

Last rows

5y_projected_popabc_egatesabiabmairport_codeairport_nameairporthubairporthub_wirelessairportnetworkaodbapc_kiosksbeaconsbfstbmsgbridgesbrsbwscargocdmcheckin_counterscityclfcommon_iwscompetition_cutecountrycountry_codecurrent_cute_servicecuss_vendorcute_contract_typecy_gdp_country_statecy_population_country_statededicated_iwsdomestic_passengeremployees_airport_authorityemployees_otheremployees_totalexpressipfidsflightyieldgatelinkgatesgeoiflowinternational_passengeriqueueitracklatitudeldcslength_longest_runwaylongitudemdnsmovementsno_kiosksnumber_sita_staffoperating_revenueowner_mgmt_grouppagingparking_spacespassengerpast_3_yr_cagr_oper_revpast_3_yr_cagr_paxpast_4_yr_cagr_gdppbmgpercent_chg_cargopercent_chg_movepercent_chg_passprojected_5_yr_cagr_popprsrmsrunwayssbdsbgsita_admin_emailsita_cutetierudswebsitework_teamyear_opened
1192NaNNaNNaNNaNVHCSAURIMO AIRPORT (VHC)NaNNaNNaNNaNNaNNaNNaNNaN0NaNNaN0NaN0NaNNaN0NaNANGOLAAONaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNCONRACNaNNaN0MEIANaNNaNNaNNaN09°41'20"SNaN0020°25'51"ENaN00NaNNaNNaNNaNNaN0NaN0.0NaNNaN0.00.00.0NaNNaNNaN0NaNNaNNaNNaN5NaNNaNNaNNaN
1193NaNNaNNaNNaNVLIBAUERFIELD INTERNATIONAL AIRPORT (VLI)Type 2, Back-Office OnlyNaNNaNNaNNaNNaNNaNNaN0NaNNaN0NaN0PORT VILANaN12SITAVANUATUVURegional AirportNaNCLUBNaNNaN12NaNNaNNaNNaNNaNNaNNaNNaN0APACNaNNaNNaNNaN17°41'57"SNaN0168°19'11"ENaN00NaNNaNNaNNaNNaN0NaN0.0NaNNaN0.00.00.0NaNNaNNaN0NaNNaNvli.cute.admins@sita.aeroREGIONAL AIRPORT5NaNhttp://www.airports.vuNaNNaN
1194NaNNaNNaNAIRIT (A1)VPSEGLIN AIR FORCE BASE (VPS)NaNNaNNaNNaNNaNNaNNaNGENTRACK0NaNNaN0NaN0VALPARAISO, FLNaN0AIRIT (A1)UNITED STATESUSNaNNaNNaNNaNNaN0NaNNaNNaNNaNSITAAIRIT (A1)NaNNaN0AMERNaNNaNNaNNaN30°28'59"NNaN3653086°31'33"WNaN00NaN7339665.0NaNNaNNaN09336733.00.0NaNNaN0.00.00.0NaNNaNAIRIT (A1)2NaNNaNNaNNaN5NaNNaNNaNNaN
1195NaNVISION-BOXNaNNaNVRAVARADERO AIRPORT (VRA)Type 0, Full APHReady For ServiceNaNNaNNaNNaNNaNSITA0ROCKWELL COLLINS (Luggage Logistics)NaN0NaN0VARADERONaN0SITACUBACUNaNNaNNaNNaNNaN0NaNNaNNaNNaNSITANaNNaNAvailable0AMERNaNNaNLEIDOS+BLIPTRACKROCKWELL COLLINS23°02'04"NNaN0081°26'07"WNaN00NaNNaNNaNNaNNaN0NaN0.0NaNNaN0.00.00.0NaNROCKWELL COLLINSNaN0SITANaNNaNAirportConnect OPEN5NaNNaNNaNNaN
1196NaNNaNNaNNaNYAOAÉROPORT INTERNATIONAL DE YAOUNDÉ-NSIMALEN (YAO)Type 0, CUTE onlyNaNNaNNaNNaNNaNNaNNaN0NaNNaN0NaN0YAOUNDÉNaN0RESACAMEROONCMNaNNaNNaNNaNNaN0NaNNaNNaNNaNSITANaNNaNNaN0MEIANaNNaNNaNNaNNaNSITA0NaNNaN007.0NaNNaNNaNNaN0NaN0.0NaNNaN0.00.00.0NaNNaNNaN0NaNNaNNaNNaN5NaNNaNSITA SGSNaN
1197NaNNaNNaNNaNYSGLUTSELKE SNOWDRIFTType 1, Full APHNaNNaNNaNNaNNaNNaNNaN0NaNNaN0NaN0Lutselke SnowdriftNaN0ULTRACANADACANaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN0AMERNaNNaNNaNNaNNaNNaN0NaNNaN00NaNNaNNaNNaNNaN0NaN0.0NaNNaN0.00.00.0NaNNaNNaN0NaNNaNNaNNaN5NaNNaNNaNNaN
1198NaNNaNNaNNaNYXULONDON INTERNATIONAL AIRPORT (YXU)NaNNaNNaNNaNNaNNaNNaNNaN0SITANaN0NaN0LONDON, ONNaN0ROCKWELL COLLINSCANADACANaNNaNNaNNaNNaN0NaNNaNNaNNaNSITANaNNaNNaN7AMERNaNNaNNaNNaN43°01'59"NNaN0081°09'03"WNaN00NaNNaNNaNNaNNaN0NaN0.0NaNNaN0.00.00.0NaNNaNNaN0NaNNaNNaNNaN5NaNhttp://www.londonairport.on.caNaNNaN
1199NaNNaNNaNNaNYYQCHURCHILL AIRPORT (YYQ)NaNNaNNaNNaNNaNNaNNaNNaN0NaNNaN0NaN0NaNNaN0ROCKWELL COLLINSCANADACANaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN0AMERNaNNaNNaNNaN58°44'20"NNaN0094°03'58"WNaN00NaNNaNNaNNaNNaN0NaN0.0NaNNaN0.00.00.0NaNNaNNaN0NaNNaNNaNNaN5NaNhttp://www.tc.gc.caNaN1942
1200NaNNaNNaNNaNZDYDELMA ISLAND AIRPORT (ZDY)Type 0, Full APHNaNNaNNaNNaNNaNNaNSITA0QUANTUMNaN0NaN0DELMA ISLANDNaN0NaNUNITED ARAB EMIRATESAENaNNaNNaNNaNNaN0NaNNaNNaNNaNSITASITANaNNaN0MEIANaNNaNNaNNaNNaNSITA0NaNSITA003.0NaNNaNNaNNaN0NaN0.0NaNNaN0.00.00.0NaNNaNNaN0NaNNaNNaNNaN5NaNNaNSITA SGSNaN
1201NaNNaNNaNNaNZYLMAG OSMANI/SYLHET OSMANY INTERNATIONAL AIRPORT...NaNReady For ServiceNaNNaNNaNNaNNaNNaN0NaNNaN0NaN0SYLHETNaN20SITABANGLADESHBDLite SiteNaNDIRECT DNaNNaN8NaNNaNNaNNaNNaNNaNNaNAvailable0APACNaNNaNNaNNaN24°57'40"NNaN0091°52'17"ENaN00NaNNaNNaNNaNNaN0NaN0.0NaNNaN0.00.00.0NaNNaNNaN0NaNNaNzyl.cute.admins@sita.aeroAirportConnect OPEN5NaNNaNNaNNaN